<?php 
     $conn = oci_connect("hospital", "hospital", "//localhost/XE"); 
    $pull = oci_parse($conn, "select * from staff where stf_id = $_GET[id]");
    oci_execute($pull);
    $job = oci_fetch_array($pull,OCI_RETURN_LOBS );
    
        
            $deleten = oci_parse($conn, "delete from FINANCES where ST_ID = '$_GET[id]'");
            oci_execute($deleten);
        
        
        $delete = oci_parse($conn, "delete from staff where STF_ID = '$_GET[id]'");
	oci_execute($delete);
        
 ?>
 
  <HTML>
 <head><meta http-equiv="refresh" content="1; URL=main.php"></head>
 <BODY>
 Going Back to the table
 </BODY>
 </HTML>
